package org.jeecg.modules.bus.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.bus.entity.BusProInfTrackData;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * @Description: 商务管理(项目信息跟踪)数据表
 * @Author: jeecg-boot
 * @Date:   2022-11-07
 * @Version: V1.0
 */
public interface BusProInfTrackDataMapper extends BaseMapper<BusProInfTrackData> {

    @Select("SELECT * from bus_pro_inf_track_data\n" +
            "WHERE create_time in (\n" +
            "SELECT MAX(l.create_time)\n" +
            "FROM bus_pro_inf_track_data l\n" +
            "GROUP BY l.pro_id)")
    public List<BusProInfTrackData> queryNewInfo();

}
